Computer Science for IGCSE & O level - Databases (Section 2 - No. 20)
What SQL command is used to add a new primary key to a table?
CREATE PRIMARY KEY
ADD PRIMARY KEY
ALTER TABLE... ADD PRIMARY KEY
UPDATE TABLE... SET PRIMARY KEY
Maelezo
The correct syntax is 'ALTER TABLE table_name ADD PRIMARY KEY (column_name);'